use lafdc

if exists (select 1 from sys.objects where name = 'routage_import' and type = 'u') drop table routage_import 
/* TABLE DEFINITION */
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ROUTAGE_IMPORT](
	_PREV_ID nvarchar(11),
	CODE varchar(3),
	DESTINATAIRE nvarchar(255),
	ADDRESS_1 nvarchar(255),
	ADDRESS_2 nvarchar(255),
	VILLE_CP nvarchar(255),
	QUANTITE int
) ON [PRIMARY]

